Neo4j Query Results

Query 1: [Execution time: 0.046872 seconds]

Retrieve the total number of matches for each competition and rename the column as 'NumberOfGames'.

Number of Records: 43

Query 2: [Execution time: 0.007980 seconds]

Retrieve all players from a specific club, FC Barcelona.

Number of Records: 62

Query 3: [Execution time: 9.049714 seconds]

Retrieve all players who have never played in the UEFA Champions League.

Number of Records: 27049

Query 4: [Execution time: 3.418888 seconds]

Count the number of appearances in the history of the database for each player.

Number of Records: 19712

Query 5: [Execution time: 5.278631 seconds]

Compute the total number of goals scored by each player in their career and indicate their playing position.

Number of Records: 19712

Query 6: [Execution time: 1.374343 seconds]

Given a certain club ID, return all the players who have played for that club.

Number of Records: 121

Query 7: [Execution time: 1.587268 seconds]

For every defender, return the total number of red cards in their career history.

Number of Records: 6381

Query 8: [Execution time: 0.023937 seconds]

Return the number of games played by each club in the UEFA Champions League.

Number of Records: 68

Query 9: [Execution time: 0.073803 seconds]

Return the number of appearances made by Lionel Messi in the UEFA Champions League.

Number of Records: 1

Query 10: [Execution time: 0.639039 seconds]

For each player, return the number of appearances in the UEFA Champions League along with the club they played for in those matches, ordered by player name and appearances.

Number of Records: 3024

Query 11: [Execution time: 20.474720 seconds]

Return the top 10 players who scored the most goals when they were under 21 years old.

Number of Records: 10

Query 12: [Execution time: 1.384179 seconds]

Return details of all games in a specific competition (Serie A) including game ID, home and away clubs, score, and date.

Number of Records: 4200

Query 13: [Execution time: 2.379843 seconds]

Return the top scorer for the top 5 competitions.

Number of Records: 5

Query 14: [Execution time: 10.559290 seconds]

Return the best striker for each club.

Number of Records: 412

Query 15: [Execution time: 0.282774 seconds]

Find clubs with the most goals scored in away matches.

Number of Records: 10

Query 16: [Execution time: 20.857031 seconds]

Find the 10 most loyal players to clubs (players who have played the most seasons with the same club compared to others).

Number of Records: 10

Query 17: [Execution time: 1.066563 seconds]

Find the best defenses for each competition.

Number of Records: 10

Query 18: [Execution time: 39.338406 seconds]

Find pairs of different players who have played together most frequently in the same games.

Number of Records: 10

Query 19: [Execution time: 51.148928 seconds]

Find pairs of different players who have played against each other most frequently.

Number of Records: 10

Query 20: [Execution time: 0.221415 seconds]

Find the oldest active players in each playing position.

Number of Records: 386